
<?php
                    include("includes/connect.php");

                    $query = "select resid from resid";
                    $result = mysql_query($query);
                    print "<SELECT name=res>";
                    print "<OPTION>-Select Residence-</OPTION>";
                    	
		    $line= mysql_fetch_array($result)
	            foreach($line as $value) 	
                    print "<OPTION value='$value'>$value</OPTION>";
                    

		    mysql_close($link);
                    print "</SELECT>";

?>

